USE StudentAttendanceChecking
GO
insert into Branch(BranchName) values ('FAT 1')
insert into Branch(BranchName) values ('FAT 2')
insert into Branch(BranchName) values ('FAT 3')
insert into Branch(BranchName) values ('FAT G')
GO
insert into TrainingProgramme(CodeTrainingName,Descriptions,StatusTraining,DefaultTraining) values ('HDSE','Higher Diploma in Software Engineering',1,2)
insert into TrainingProgramme(CodeTrainingName,Descriptions,StatusTraining,DefaultTraining) values ('ACCP','Afterschool Child Care Program ',1,1)
GO
insert into GroupUser(GroupName) values('Teacher')
insert into GroupUser(GroupName) values('Staff')
insert into GroupUser(GroupName) values('Administrator')
go
insert into Users(UsersName,Account,Passwords,Active,GroupUserID) values ('Nguyen Tuan','tuann','1',1,1)
insert into Users(UsersName,Account,Passwords,Active,GroupUserID) values ('Nguyen Huy Hoang','hoangnh','1',1,1)
insert into Users(UsersName,Account,Passwords,Active,GroupUserID) values ('Hoang Huong Giang','gianghh','1',1,1)
insert into Users(UsersName,Account,Passwords,Active,GroupUserID) values ('Hoang Thanh Tung','tunght','1',1,1)
insert into Users(UsersName,Account,Passwords,Active,GroupUserID) values ('Nguyen Kim Thi','think','1',1,1)
GO
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C1010G',1,1,'7h30 - 11h30','10/2/2011','10/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0710G',2,2,'7h30 - 11h30','10/2/2011','10/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0910G',3,3,'7h30 - 11h30','10/2/2011','10/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0709I',4,4,'7h30 - 11h30','10/2/2011','10/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0609I',5,2,'7h30 - 11h30','10/2/2011','10/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C1110G',3,1,'7h30 - 11h30','10/2/2011','10/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0606G',4,3,'7h30 - 11h30','8/2/2011','8/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0309I',2,4,'7h30 - 11h30','5/2/2011','5/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0102G',5,1,'7h30 - 11h30','5/2/2011','5/2/2013',1)
insert into Class(ClassName,UsersID,BranchID,TimeSlot,StartDay,EndDay,ClassStatus) values ('C0111G',1,3,'7h30 - 11h30','6/2/2011','6/2/2013',1)
GO
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('WFC#-I','Winform C Sharp-I',13,12,3)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('WFC#-II','Winform C Sharp-II',12,11,3)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('WEB-I','WEB-I',11,11,3)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('WEB-II','WEB-II',10,10,3)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('WCF','Winform Fundamental',10,9,3)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('WCC','WCC',12,13,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('EPJ-III','EPJ',10,10,3)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('SDO','SDO',12,13,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('JP1','Java Programming I',13,13,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('JP2','Java Programming II',13,13,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('XML','XML Simplified',4,3,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('APJ1','Advance Programming in Java 1',12,13,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('APJ2','Advance Programming in Java 2',12,13,2)
insert into Subjects(SubjectCode,SubjectName,SubjectTotalW,SubjectTotalP,Sem) values ('PCS','Programming in C Sharp',12,13,2)
GO
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04236','Trang Quang Hai',1,'10/22/1990','233 Giai Phong-Ha Noi','0986798484','haiquang@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04237','Ngo Quynh Anh',0,'8/11/1992','423 Tran Quang Khai - Hai Phong','012356859','quynhanh@yahoo.com',1,'HDSE','Chua dong tien dat coc',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04238','Do Huy Hoang',1,'10/2/1989','Ngo Cho Kham Thien - Ha Noi','01234581992','hoangdo@gamil.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04239','Nguyen Van Phong',1,'7/3/1986','Ngoc Lam - Gia Lam - Ha Noi','0922252225','phongnv@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04240','Nguyen Thi Anh',0,'3/12/1990','My Van Hung Yen','0987666886','anhtn@live.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04241','Doan Tuan Anh',1,'7/11/1981','622/17/15 Ha Huy Tap - Gia Lam - Ha Noi','0986798381','anhdt@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04242','Dang Van Quan',1,'10/22/1984','Bach Dang','012358565','quan@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04243','Tran Quang Khai',1,'10/22/1990','233 Giai Phong','0986798484','khai@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04244','Ngo Thanh Huong',0,'10/11/1992','Cau Giay','0986798484','huong@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04245','Bui Thanh Ha',1,'10/22/1990','233 Giai Phong','0986798484','ha@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04246','Hoang Quoc Viet',1,'10/22/1990','233 Giai Phong','0986798484','quocviet@hotmail.com',1,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04247','Ngo Ba Thuy',1,'10/22/1990','233 Giai Phong','0986798484','thuy@hotmail.com',1,'HDSE','Khong co gi',0)

----lop 2
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04248','Trang Quang Hieu',1,'10/22/1990','22- Xuan Dieu - Ha Noi','0986798484','hieuquangtrang@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04249','Ngo Quynh An',0,'8/11/1992','423 Tran Nhan Duat - Hai Duong','012356859','quynhan@yahoo.com',2,'HDSE','Chua dong tien dat coc',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04250','Do Huy Tien',1,'10/2/1989','35 Kham Thien - Ha Noi','01234581992','tiendh@gamil.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04251','Nguyen Hai Le',1,'7/4/1988',' Huyen Gia Lam - Ha Noi','0922252225','lenh@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04252','Bui Thi Anh',0,'3/12/1990','My Van Hung Yen','0987666886','anhtb@live.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04253','Quach Tuan Anh',1,'7/11/1981','555/18/19 Ha Huy Tap - Gia Lam - Ha Noi','0986798381','anhdt@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04254','Ba Van Quan',1,'10/22/1984','Bach Dang','012358565','quanba@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04255','Ho Quang Khai',1,'10/22/1990','233 Giai Phong','0986798484','hoquangkhai@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04256','Ta Thanh Huong',0,'10/11/1992','Lo Duc- Ha Noi','0986798484','huongtathanh@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04257','Trinh Thanh Ha',1,'10/22/1990','255 Giai Phong','0986798484','ha@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04258','Le Quoc Viet',1,'10/22/1990','33 Hang Than - Ha Noi','0986798484','quocviet@hotmail.com',2,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04259','Cong Ba Thuy',1,'10/22/1990','1 Hoang Dieu - Ha Noi','0986798484','thuycongba@hotmail.com',2,'HDSE','Khong co gi',0)

--lop 3
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04260','Trang Quang Hanh',1,'10/1/1990','22- Xuan Dieu - Ha Noi','0986798484','hanhtq@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04261','Ngo Thi Binh',0,'8/2/1992','423 Tran Nhan Duat - Hai Duong','012356859','binhnt@yahoo.com',3,'HDSE','Chua dong tien dat coc',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04262','Do Tien Huy',1,'10/3/1989','35 Kham Thien - Ha Noi','01234581992','huydt@gamil.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04263','Nguyen Le Hai',1,'1/4/1988',' Huyen Gia Lam - Ha Noi','0922252225','lehainguyen@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04264','Bui Anh Thi',0,'5/5/1990','My Van Hung Yen','0987666886','anhthi@live.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04265','Quach Anh Tuan',1,'6/6/1981','555/18/19 Ha Huy Tap - Gia Lam - Ha Noi','0986798381','tuanqa@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04266','Ba Quan Van',1,'6/7/1984','Bach Dang','012358565','vanbq@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04267','Ho Khai Quang',1,'7/8/1990','233 Giai Phong','0986798484','quanghk@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04268','Ta Thanh',0,'8/9/1992','Lo Duc- Ha Noi','0986798484','tathanh@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04269','Trinh Ha Thanh',1,'9/10/1990','255 Giai Phong','0986798484','hathanhtrinh@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04270','Le Viet Quoc',1,'11/11/1990','33 Hang Than - Ha Noi','0986798484','quoc_viet_le@hotmail.com',3,'HDSE','Khong co gi',0)
insert into Student(StudentID,Name,Gender,BirthDay,Addresss,Phone,Email,CurrentClassID,CodeTrainingName,Descriptions,StudentStatus) values ('a04271','Cong Thuy Ba',1,'12/22/1990','1 Hoang Dieu - Ha Noi','0986798484','thuyba_cong@hotmail.com',3,'HDSE','Khong co gi',0)
--insert into Attendance
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(1,3,'WFC#-I','2/1/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(1,3,'WFC#-I','2/2/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(1,3,'WFC#-I','2/3/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(1,3,'WFC#-I','2/4/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(1,3,'WFC#-I','2/5/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(1,3,'WFC#-I','2/6/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(2,4,'WFC#-II','2/1/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(2,4,'WFC#-II','2/2/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(3,5,'SDO','2/1/2012')
insert into Attendants(UsersID,ClassID,SubjectCode,AttendantsDate) values(3,5,'SDO','2/2/2012')


-- attendance details
-- class 1 Writting
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04236',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04237',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04238',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04239',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04240',2,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04241',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04242',0,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04243',1,0,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04244',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04245',1,0,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04246',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(1,'a04247',1,1,'2/1/2012','Nothing')

insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04236',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04237',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04238',0,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04239',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04240',2,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04241',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04242',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04243',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04244',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04245',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04246',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(2,'a04247',1,1,'2/2/2012','Nothing')


insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04236',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04237',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04238',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04239',1,2,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04240',1,0,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04241',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04242',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04243',1,0,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04244',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04245',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04246',1,1,'2/3/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(3,'a04247',1,1,'2/3/2012','Nothing')

-- class 1 Practice
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04236',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04237',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04238',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04239',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04240',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04241',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04242',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04243',1,0,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04244',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04245',1,0,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04246',1,1,'2/4/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(4,'a04247',1,1,'2/4/2012','Nothing')

insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04236',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04237',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04238',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04239',1,0,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04240',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04241',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04242',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04243',1,0,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04244',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04245',1,0,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04246',1,1,'2/5/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(5,'a04247',1,1,'2/5/2012','Nothing')


insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04236',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04237',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04238',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04239',1,2,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04240',1,0,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04241',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04242',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04243',1,0,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04244',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04245',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04246',1,1,'2/6/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(6,'a04247',1,1,'2/6/2012','Nothing')

--class2 writting
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04248',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04249',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04250',0,0,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04251',2,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04252',1,2,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04253',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04254',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04255',1,0,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04256',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04257',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04258',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(7,'a04259',1,1,'2/1/2012','Nothing')

insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04248',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04249',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04250',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04251',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04252',1,2,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04253',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04254',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04255',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04256',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04257',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04258',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(8,'a04259',1,1,'2/2/2012','Nothing')

--class 3 
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04260',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04261',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04262',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04263',1,0,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04264',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04265',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04266',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04267',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04268',1,0,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04269',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04270',1,1,'2/1/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(9,'a04271',1,1,'2/1/2012','Nothing')


insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04260',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04261',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04262',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04263',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04264',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04265',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04266',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04267',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04268',1,0,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04269',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04270',1,1,'2/2/2012','Nothing')
insert into AttendantsDetails(AttendantsID,StudentID,AttendantsStatusW,AttendantsStatusP,AttendantsDetailsDateTime,Note) values(10,'a04271',1,1,'2/2/2012','Nothing')

